MATCH_TRANSPORT_BY_ID = "MATCH (m:MaterialTransport {materialTransportId: $materialTransportId}) RETURN m"
# 可继续补充material_transport相关Cypher语句 

GET_MATERIAL_TRANSPORT_LIST = '''
MATCH (m:MaterialTransport)
{where}
RETURN m
'''

CREATE_MATERIAL_TRANSPORT = '''
CREATE (m:MaterialTransport {
    materialTransportId: $materialTransportId,
    materialTransportName: $materialTransportName,
    createdBy: $createdBy,
    createdAt: $createdAt,
    updatedBy: $updatedBy,
    updatedAt: $updatedAt
})
RETURN m
'''

UPDATE_MATERIAL_TRANSPORT = 'MATCH (m:MaterialTransport {materialTransportId: $materialTransportId}) SET {set_clauses} RETURN m'

DELETE_MATERIAL_TRANSPORT_REL = 'MATCH (b:WorkBench)-[r:WORKBENCH_TRANSPORT]->(m:MaterialTransport {materialTransportId: $materialTransportId}) DELETE r'

DELETE_MATERIAL_TRANSPORT = 'MATCH (m:MaterialTransport {materialTransportId: $materialTransportId}) DETACH DELETE m'

CHECK_MATERIAL_TRANSPORT_EXISTS = "MATCH (m:MaterialTransport {materialTransportId: $materialTransportId}) RETURN m" 